DAX Formulas for PowerPivot by Rob Collie

Author:Rob Collie
Language: ara
Format: epub
Tags: big data, data analysis, data scientist, excel, excel 2012, excel 2013, finance, microsoft, msbi, pivot table, pivottable, powerpivot, sharepoint, spreadsheets, DAX, formulas
Publisher: Holy Macro! Books
Published: 2014-02-11T16:00:00+00:00

Figure 180 Calendar table – now we can get started!

Now I relate it to my Sales table, using the Date columns:

Figure 181 Relating Calendar to Sales

In PowerPivot v1, the column used to relate Calendar to other tables had to be of data type Date. In v2, you can now relate using a column of a different data type, such as an integer, so you do not need a column of Type Date in your Sales table anymore, but you do still need a column of type Date in your Calendar table.

Figure 182 Updated diagram view: Calendar becomes the third lookup table

Operates Like a Normal Lookup Table

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.